package com.hmall.mapper;

import com.hmall.model.MallProductForwardStock;
import com.hmall.util.MyMapper;
import com.hmall.vo.stock_price;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface MallProductForwardStockMapper extends MyMapper<MallProductForwardStock> {
    MallProductForwardStock selectForwardStock(@Param("inventory_organization") String inventory_organization,@Param("material_code") String material_code,@Param("grade") String grade,@Param("twisting") String twisting,@Param("color") String color,@Param("machine_no") String machine_no);

    List<MallProductForwardStock> selectByCode(@Param("code") String code,@Param("pageStart") Integer pageStart,@Param("pageSize") Integer pageSize);

    List<MallProductForwardStock> selectByModelAndGrade(@Param("model") String model,@Param("twisting") String twisting,@Param("grade") String[] grade,@Param("color")String color);

    void deleteAll();

    List<stock_price> test();

    int selectViewCount();
}